EMT Practice Test

1. Question Content...

---

Question1: Why would you create calculation views of data category DIMENSION with type TIME?

Question2: Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

Question3: Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

Question4: Which project structure object corresponds to a unique HDI container?

Question5: What is a restricted measure?

Question6: What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

Question7: You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.

When you preview calculation view A, the account number is not masked.What could be the reason?

Question8: You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

Question9: How can you define a variable that presents its value help hierarchically? Note: There are 2 correct answers to this question.

Question10: You have products that appear in table A and sometimes they also appear in table B. You want to select the products that appear ONLY in tableA. Which node type do you use?

Question11: You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

Question12: Why would you use the Transparent Filter property in a calculation view?

Question13: Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

Question14: What do you use in the definition of a dynamic SQL analytic privilege?

Question15: In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

Question16: You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

Question17: What are the key steps to implement currency conversion in a calculation view?

Question18: Why would you choose to implement a referential join?

Question19: Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

Question20: Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

Question21: You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

Question22: You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?

Question23: In SAP HANA Cloud, which tasks are handled by the cloud provider?Note: There are 3 correct answers to this question.Sizing, provisioning, and monitoring the database

Question24: In a calculated column, which object do you use to process a dynamic value in an expression?

Question25: In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

Question26: You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

Question27: You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

Question28: In a calculation view, what is the purpose of a variable?

Question29: Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.

Question30: You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.

However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

Question31: What is the objective of calculation view instantiation?

Question32: What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.

Question33: You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

Question34: Why might you use the Keep Flag property in an aggregation node?

Question35: In a database module, what is the purpose of the .hdiconfig file?

Question36: What is the SQL keyword used to process input parameters defined in a calculation view?

Question37: Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

Question38: What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

Question39: A new version of SAP HANA Cloud, SAP HANA database is available from today.If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

Question40: What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

Question41: What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.